namespace JHErp.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class ErpInit : DbMigration
    {
        public override void Up()
        {
            CreateTable(
                "dbo.AlibabaOrders",
                c => new
                    {
                        order_id = c.String(nullable: false, maxLength: 128),
                        B = c.String(),
                        C = c.String(),
                        D = c.String(),
                        E = c.String(),
                        F = c.String(),
                        G = c.String(),
                        H = c.String(),
                        I = c.String(),
                        J = c.String(),
                        K = c.String(),
                        L = c.String(),
                        M = c.String(),
                        N = c.String(),
                        O = c.String(),
                        P = c.String(),
                        Q = c.String(),
                        R = c.String(),
                        S = c.String(),
                        T = c.String(),
                        U = c.String(),
                        V = c.String(),
                        W = c.String(),
                        X = c.String(),
                        Y = c.String(),
                        Z = c.String(),
                        AA = c.String(),
                        AB = c.String(),
                        AC = c.String(),
                        AD = c.String(),
                        AE = c.String(),
                        AF = c.String(),
                        AG = c.String(),
                        AH = c.String(),
                        AI = c.String(),
                        AJ = c.String(),
                        AK = c.String(),
                        AL = c.String(),
                        AM = c.String(),
                        AN = c.String(),
                        AO = c.String(),
                    })
                .PrimaryKey(t => t.order_id);
            
            CreateTable(
                "dbo.AlipayRecords",
                c => new
                    {
                        trade_no = c.String(nullable: false, maxLength: 128),
                        order_id = c.String(),
                        trade_date = c.String(),
                        paid_date = c.String(),
                        last_updated = c.String(),
                        trade_src = c.String(),
                        trade_type = c.String(),
                        trade_with = c.String(),
                        goods_name = c.String(),
                        amount = c.String(),
                        in_out = c.String(),
                        trade_status = c.String(),
                        service_charges = c.String(),
                        refunds = c.String(),
                        remarks = c.String(),
                        fund_status = c.String(),
                    })
                .PrimaryKey(t => t.trade_no);
            
            CreateTable(
                "dbo.TaobaoOrders",
                c => new
                    {
                        order_id = c.String(nullable: false, maxLength: 128),
                        buyer_nick = c.String(),
                        buyer_alipay = c.String(),
                        buyer_payable = c.String(),
                        E = c.String(),
                        F = c.String(),
                        G = c.String(),
                        H = c.String(),
                        I = c.String(),
                        J = c.String(),
                        K = c.String(),
                        L = c.String(),
                        M = c.String(),
                        N = c.String(),
                        O = c.String(),
                        P = c.String(),
                        Q = c.String(),
                        R = c.String(),
                        S = c.String(),
                        T = c.String(),
                        U = c.String(),
                        V = c.String(),
                        W = c.String(),
                        X = c.String(),
                        Y = c.String(),
                        Z = c.String(),
                        AA = c.String(),
                        AB = c.String(),
                        AC = c.String(),
                        AD = c.String(),
                        AE = c.String(),
                        AF = c.String(),
                        AG = c.String(),
                        AH = c.String(),
                        AI = c.String(),
                        AJ = c.String(),
                        AK = c.String(),
                        AL = c.String(),
                        AM = c.String(),
                        AN = c.String(),
                        AO = c.String(),
                        AP = c.String(),
                        AQ = c.String(),
                        AR = c.String(),
                        AS = c.String(),
                    })
                .PrimaryKey(t => t.order_id);
            
        }
        
        public override void Down()
        {
            DropTable("dbo.TaobaoOrders");
            DropTable("dbo.AlipayRecords");
            DropTable("dbo.AlibabaOrders");
        }
    }
}
